﻿	CREATE TABLE public.student
	(
	    /***************************************************************************************************
	    **  Table:	    public.student
	    **  Author:		Zhixian Ong
	    **
	    **  Description:
	    **    
	    **    Represents a registered student.
	    **
	    **  Fields (2):
	    **
	    **      id              - candidate key; running number 
	    **      full_name       -
	    **      display_name    -
	    **      nationality_id  -
	    **
	    **  Constaints (2):
	    **
	    **      student_pk  - 
	    **      student_uc  -
	    **
	    **  Modification History:
	    **
	    **      20140102  Zhixian Ong     - Initial prototype
	    ** 
	    **  Status:
	    **      Dev
	    ** 
	    ***************************************************************************************************/
        
	    -- [Fields]
	    id              integer                 NOT NULL DEFAULT nextval('student_id_seq'),
	    full_name       character varying(128)  NOT NULL, 
	    display_name    character varying(128)  NOT NULL,
	    nationality_id  character varying(36)   NOT NULL,
        
	    -- [Constraints]
	    CONSTRAINT student_pk   PRIMARY KEY ("id"),
	    CONSTRAINT student_uc   UNIQUE ("nationality_id")
	);